When attempting to open a table within Microsoft Excel using the SAS Add-In for Microsoft Office, you might receive the following error:

SAS Add-In
Unable to open "SASApp:ORALIB.CLASS".
The object invoked has disconnected from its clients. (Exception from HRESULT:
0x80010108 (RPC_E_DISCONNECTED))
--------------------------------------------------------------------------------
Exception information
--------------------------------------------------------------------------------
The object invoked has disconnected from its clients. (Exception from HRESULT:
0x80010108 (RPC_E_DISCONNECTED))
-------------------------- Technical Information Follows--------------------------
Exception Details:
----------------------------------------
Exception type:  System.Runtime.InteropServices.COMException
Message:         The object invoked has disconnected from its clients.
(Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))
Source:          mscorlib
Target Site:     EndInvokeHelper

Stack Trace:

Server stack trace:
   at SAS.LibrefClass.LevelInfo(Array& FieldInclusionMask, Array& EngineName,
Array& EngineAttrs, Array& LibraryAttrs, Array& PhysicalName, Array&
InfoPropertyNames, Array& InfoPropertyValues)
   at SAS.Servers.DataLibrary.GetLibraryInfo(IList`1& enginesResolved, IList`1&
enginesUnresolved, Boolean& isDbms, Boolean& keepAllDataInMemory)
   at SAS.Servers.DataLibrary.Connect()
   at SAS.Servers.Dataset.Open(Boolean readOnly)
   at SAS.Servers.Dataset.Open()
   at SAS.OfficeAddin.OfficeAddinBase.OpenDatasetWithPasswordPrompt(Dataset
dataset, Boolean readOnly)
   at SAS.OfficeAddin.SasDataSource.OpenProc(Boolean readOnly)
   at SAS.OfficeAddin.SasDataSource.OpenProc()
   at
System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr
md, Object[] args, Object server, Object[]& outArgs)
   at
System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage
msg, IMessageSink replySink)
 

This typically happens for DBMS libraries that are not pre-assigned.

To avoid this problem, you can take one of the following actions:

• Pre-assign the library within SAS^® Management Console.
• Submit the metadata LIBNAME statement within the SAS Programs window in the SAS Add-In.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Add-In for Microsoft Office 8.0 is available at:

A fix for this issue for SAS Visual Analytics Add-In for Office 8.0 is available at: